create EXTERNAL table jms_dm.dm_pre_rate_agent_summary_dt (
    date_time string comment '自有平台日期',
    data_type tinyint comment '数据类型 1揽收 2时效签收 3规划签收',
    island_code string comment '订单来源code',
    island_name string comment '订单来源name',
    start_subordinate_agent_code string comment '始发代理区code',
    start_subordinate_agent_name string comment '始发代理区name',
    sign_subordinate_agent_code string comment '签收代理区name',
    sign_subordinate_agent_name string comment '签收代理区name',
    start_subordinate_virt_code string comment '始发虚拟代理区code',
    start_subordinate_virt_name string comment '始发虚拟代理区name',
    sign_subordinate_virt_code string comment '签收虚拟代理区name',
    sign_subordinate_virt_name string comment '签收虚拟代理区name',
    plan_pdd_date string comment '桃花岛规划签收日期',
    plan_mountain_date string comment '紫金山规划签收日期',
    plan_free_date string comment '逍遥峰规划签收日期',
    plan_jd_date string comment '极地湾超长规划签收日期',
    plan_cainiao_date string comment '七星潭规划签收日期',
    plan_cainiao_pro_date string comment '七星潭计划规划签收日期',
    plan_mountain_pro_date string comment '紫金山超长规划签收日期',
    is_districtprescription tinyint comment '始发自由平台数据 1是 0否',
    real_reach_sum bigint comment '实际达成票数',
    real_total bigint comment '实际总票数',
    pres_reach_sum bigint comment '时效达成票数',
    pres_total bigint comment '时效总票数',
    is_platform_effect tinyint comment '是否桃花岛数据 1是 0否',
    real_platform_reach_sum bigint comment '实际桃花岛达成票数',
    real_platform_total bigint comment '实际桃花岛总票数',
    pres_platform_reach_sum bigint comment '时效桃花岛达成票数',
    pres_platform_total bigint comment '时效桃花岛总票数',
    is_mountain_platform_effect tinyint comment '是否紫金山数据 1是 0否',
    mountain_real_platform_reach_sum bigint comment '实际紫金山达成票数',
    mountain_real_platform_total bigint comment '实际紫金山总票数',
    mountain_pres_platform_reach_sum bigint comment '时效紫金山达成票数',
    mountain_pres_platform_total bigint comment '时效紫金山总票数',
    is_free_platform_effect tinyint comment '是否逍遥峰数据 1是0否',
    free_real_platform_reach_sum bigint comment '逍遥峰实际达成票数',
    free_real_platform_total bigint comment '逍遥峰实际总票数',
    free_pres_platform_reach_sum bigint comment '逍遥峰时效达成票数',
    free_pres_platform_total bigint comment '逍遥峰时效总票数',
    is_jd_platform_effect tinyint comment '是否极地湾数据 1是0否',
    jd_real_platform_reach_sum bigint comment '极地湾实际达成票数',
    jd_real_platform_total bigint comment '极地湾实际总票数',
    jd_pres_platform_reach_sum bigint comment '极地湾时效达成票数',
    jd_pres_platform_total bigint comment '极地湾时效总票数',
    is_cainiao_platform_effect tinyint comment '是否七星潭数据 1是0否',
    cainiao_real_platform_reach_sum bigint comment '七星潭实际达成票数',
    cainiao_real_platform_total bigint comment '七星潭实际总票数',
    cainiao_pres_platform_reach_sum bigint comment '七星潭时效达成票数',
    cainiao_pres_platform_total bigint comment '七星潭时效总票数',
    is_cainiao_pro_platform_effect tinyint comment '是否七星潭计划数据 1是0否',
    cainiao_pro_real_platform_reach_sum bigint comment '七星潭计划峰实际达成票数',
    cainiao_pro_real_platform_total bigint comment '七星潭计划实际总票数',
    cainiao_pro_pres_platform_reach_sum bigint comment '七星潭计划时效达成票数',
    cainiao_pro_pres_platform_total bigint comment '七星潭计划时效总票数',
    is_mountain_pro_platform_effect tinyint comment '是否紫金山超长数据 1是0否',
    mountain_pro_real_platform_reach_sum bigint comment '紫金山超长实际总票数',
    mountain_pro_real_platform_total bigint comment '紫金山超长实际总票数',
    mountain_pro_pres_platform_reach_sum bigint comment '紫金山超长时效达成票数',
    mountain_pro_pres_platform_total bigint comment '紫金山超长时效总票数',
    real_zeroday_num bigint comment '实际当日达票数',
    real_oneday_num bigint comment '实际一日达票数',
    real_twoday_num bigint comment '实际二日达票数',
    real_threeday_num bigint comment '实际三日达票数',
    real_four_num bigint comment '实际四日达票数',
    real_five_num bigint comment '实际五日达票数',
    real_six_num bigint comment '实际六日达票数',
    pres_zeroday_num bigint comment '时效当日达',
    pres_oneday_num bigint comment '时效一日达',
    pres_twoday_num bigint comment '时效二达',
    pres_threeday_num bigint comment '时效三日达',
    pres_four_num bigint comment '时效四日达',
    pres_five_num bigint comment '时效五日达',
    pres_six_num bigint comment '时效六日达',
    jd_real_one_num bigint comment '极地湾实际24小时达',
    jd_real_two_num bigint comment '极地湾实际36小时达',
    jd_real_three_num bigint comment '极地湾实际48小时达',
    jd_real_four_num bigint comment '极地湾实际60小时达',
    jd_real_five_num bigint comment '极地湾实际72小时达',
    jd_real_six_num bigint comment '极地湾实际96小时达',
    jd_real_seven_num bigint comment '极地湾实际120小时达',
    jd_pre_one_num bigint comment '极地湾时效24小时达',
    jd_pre_two_num bigint comment '极地湾时效36小时达',
    jd_pre_three_num bigint comment '极地时效际48小时达',
    jd_pre_four_num bigint comment '极地湾时效60小时达',
    jd_pre_five_num bigint comment '极地湾时效72小时达',
    jd_pre_six_num bigint comment '极地湾时效96小时达',
    jd_pre_seven_num bigint comment '极地湾时效120小时达'
)     COMMENT '兔集达成率明细'
PARTITIONED BY (
  `dt` string COMMENT '统计日期')
 STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_pre_rate_agent_summary_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );